To purge activity attachments created before a specified date
To delete activity attachments with a timestamp before a specified date, you must modify the Purge old Activity attachments report spec to include a date in the purge script from which you want to delete activity attachments, and then run the purge script.
Note: You must have an authorization level of 8 or higher to modify a report spec.
Note: The FILE_TIMESTAMP date that you modify in the purge activity attachment script refers to the date that displays in the File Date column on the Activity Attachment window for the attachment. The File Date displays the date the attachment was last modified. However, if the attachment has not been modified, the date that displays corresponds to the date the file was created.
delete Activity_Attach where FILE_TIMESTAMP< '20021010' and ACTIVITY_SEQN> 0 and READ_ONLY=0
Note: In an environment where users are importing activities simultaneously, you must ensure that the users do not attempt to import the same files or run the same queries. To prevent a user from inadvertently affecting records another user is processing, you can limit access to the advanced Activity Importer features so that processing is restricted to records imported by a user's specific session.
10.6 Production Release. Updated 2/23/2006 12:01:42 PM
© Copyright by Advanced Solutions International, Inc.
All rights reserved.